<html>
<head>
<title> Creating or Importing a Database </title>
<meta name="Keywords" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="stylesheet.css"/>
<script src="locate.js"></script>
<link href="prettify.css" type="text/css" rel="stylesheet" />
<script type="text/javascript" src="prettify.js"></script>
</head>
<script src="highlight.js"></script>
<body bgcolor="#FFFFFF" text="#000000" link="#0000A0" alink="#008000" vlink="#FF0000" onLoad="FindCorrectTOCPage(); prettyPrint()">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="top">
<td>
<p class="pagenavigation"><a href="17301.htm" target="_self"><img src="38976.gif" alt="Previous page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"> Previous page</a></p></td>
<td>
<p class="pagenavigation"><a href="29038.htm" target="_self"><img src="38977.gif" alt="Next page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"> Next page</a></p></td>
<td>
<p class="pagenavigation"><a href="toc41518115.htm" target="TOC"><img src="38970.gif" alt="Locate page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"> Locate page</a></p></td>
<td>
<p class="pagenavigation"><a href="toc41518115.htm" target="TOC"><a class="" title="" href="javascript:print();" target="_self"><img src="39072.gif" alt="Print this page" height="16" width="16" vspace="0" hspace="1" align="top" border="0"></a></a></p></td>
</tr>
</table>
<h4 class="heading4">Creating or Importing a Database</h4>
<p class="procedureheading">To create a new database on a hosting account:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Click the <strong class="specialbold">Domains</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber">Click the required domain name in the list.</li><li class="procedurelistnumber">Click <strong class="specialbold">Databases</strong>.</li><li class="procedurelistnumber">Click <strong class="specialbold">Add New Database</strong>.</li><li class="procedurelistnumber">Enter a name for the database. <p class="listcontinue">We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols). </p>
</li><li class="procedurelistnumber">Select the database type that you are going to use: MySQL or PostgreSQL. </li><li class="procedurelistnumber">Select the database server of the selected type from the list. Click <strong class="specialbold">OK</strong>.</li><li class="procedurelistnumber">To set up database administrator's credentials, click <strong class="specialbold">Add New Database User</strong>.</li><li class="procedurelistnumber">Type a user name and a password that will be used for accessing the contents of the database.</li><li class="procedurelistnumber">Click <strong class="specialbold">OK</strong>.  </li></ol><p class="bodytext"></p>
<p class="procedureheading">To import an existing database:</p>
<ol class="procedurelistnumber"><li class="procedurelistnumber">Click the <strong class="specialbold">Domains</strong> shortcut in the navigation pane.</li><li class="procedurelistnumber">Click the required domain name in the list.</li><li class="procedurelistnumber">Click <strong class="specialbold">Databases</strong>.</li><li class="procedurelistnumber">Click <strong class="specialbold">Add New Database</strong>.</li><li class="procedurelistnumber">Enter a name for the database. We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols). </li><li class="procedurelistnumber">Select the database type that you are going to use: MySQL or PostgreSQL. </li><li class="procedurelistnumber">Select the database server of the selected type from the list. Click <strong class="specialbold">OK</strong>.</li><li class="procedurelistnumber">To set up database administrator's credentials, click <strong class="specialbold">Add New Database User</strong>.</li><li class="procedurelistnumber">Type a user name and a password that will be used for accessing the contents of the database. Click <strong class="specialbold">OK</strong>.</li><li class="procedurelistnumber">Click the <strong class="specialbold">DB WebAdmin</strong> icon in the <strong class="specialbold">Tools</strong> group. An interface to phpMyAdmin (or phpPgAdmin) database management tool will open in a separate browser window.</li><li class="procedurelistnumber">Click on the <strong class="specialbold">Query window</strong> icon in the left frame.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Import files</strong> tab.</li><li class="procedurelistnumber">Select the text file that contains the data and click <strong class="specialbold">Go</strong>.</li><li class="procedurelistnumber">Click the <strong class="specialbold">Insert data from a text file</strong> link.</li></ol><p class="bodytext">To manage your databases and their contents, use your favorite MySQL or PostgreSQL client or the web based database management tool accessible from Plesk control panel (<strong class="specialbold">Domains </strong>&gt;<strong class="specialbold"> domain name </strong>&gt;<strong class="specialbold"> Databases </strong>&gt;<strong class="specialbold"> Database name </strong>&gt;<strong class="specialbold"> DB WebAdmin</strong>). </p>
<p class="bodytext"></p>


</body>
<script>highlightTOC()</script>
</html>

